[dbo].[asi_SetNameAllViewPermissions]

SQLServer > iMIS1521GA > Stored Procedures > dbo.asi_SetNameAllViewPermissions

Property	Value
ANSI Nulls On
Quoted Identifier On

-- =============================================
-- Author:        Paul Bradshaw
-- Create date: Jan 30th, 2007
-- Description:    Set Name_All View permissions
-- =============================================
CREATE PROCEDURE asi_SetNameAllViewPermissions
AS
BEGIN
    -- SET NOCOUNT ON added to prevent extra result sets from
    -- interfering with SELECT statements.
    SET NOCOUNT ON;

    GRANT INSERT, DELETE, REFERENCES, SELECT, UPDATE ON Name_All TO IMIS
END

GO